﻿//
// (C) Copyright 2009 Irantha Suwandarathna (iranthas@hotmail.com)
//

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace EffiProz.Explorer
{
    class Utils
    {
        public static String[] selectHelp = {
        "SELECT * FROM ",

        "SELECT [LIMIT n m] [DISTINCT] \n"
        + "{ selectExpression | table.* | * } [, ... ] \n"
        + "[INTO [CACHED|TEMP|TEXT] newTable] \n" + "FROM tableList \n"
        + "[WHERE Expression] \n"
        + "[ORDER BY selectExpression [{ASC | DESC}] [, ...] ] \n"
        + "[GROUP BY Expression [, ...] ] \n"                             //
        + "[UNION [ALL] selectStatement]"
    };
        public static String[] insertHelp = {
        "INSERT INTO ",
        "INSERT INTO table [ (column [,...] ) ] \n"
        + "{ VALUES(Expression [,...]) | SelectStatement }"
    };
        public static String[] updateHelp = {
        "UPDATE ",
        "UPDATE table SET column = Expression [, ...] \n"
        + "[WHERE Expression]"
    };
        public static String[] deleteHelp = {
        "DELETE FROM ", "DELETE FROM table [WHERE Expression]"
    };
        public static String[] createTableHelp = {
        "CREATE TABLE ",
        "CREATE [TEMP] [CACHED|MEMORY|TEXT] TABLE name \n"
        + "( columnDefinition [, ...] ) \n\n" + "columnDefinition: \n"
        + "column DataType [ [NOT] NULL] [PRIMARY KEY] \n" + "DataType: \n"
        + "{ INTEGER | DOUBLE | VARCHAR | DATE | TIME |... }"
    };
        public static String[] dropTableHelp = {
        "DROP TABLE ", "DROP TABLE table"
    };
        public static String[] createIndexHelp = {
        "CREATE INDEX ",
        "CREATE [UNIQUE] INDEX index ON \n" + "table (column [, ...])"
    };
        public static String[] dropIndexHelp = {
        "DROP INDEX ", "DROP INDEX table.index"
    };
        public static String[] checkpointHelp = {
        "CHECKPOINT", "(EffiProz SQL only)"
    };
        public static String[] scriptHelp = {
        "SCRIPT", "SCRIPT ['file']\n\n" + "(EffiProz SQL only)"
    };
        public static String[] shutdownHelp = {
        "SHUTDOWN",
        "SHUTDOWN [COMPACT|IMMEDIATELY|SCRIPT]\n\n" + "(EffiProz SQL only)"
    };
        public static String[] setHelp = {
        "SET ",

        "SET AUTOCOMMIT { TRUE | FALSE }\n"
        + "SET DATABASE COLLATION \"<collationname>\"\n"
        + "SET FILES CHECKPOINT DEFRAG <size>\n"
        + "SET DATABASE INITIAL SCHEMA <schemaname>\n"                             //
        + "SET FILES LOG SIZE <size>\n"                                          //
        + "SET MAXROWS maxrows\n"                                         //
        + "SET PASSWORD <password>\n"                                     //
        + "SET FILES READONLY { TRUE | FALSE }\n"
        + "SET SCHEMA <schemaname>\n"
        + "SET TABLE <tablename> READONLY { TRUE | FALSE }\n"
        + "SET TABLE <tablename> SOURCE \"<file>\" [DESC]\n"
        + "\n\n"                                                          //
        + "(EffiProz SQL only)"
    };
        

    }
}
